Airbnb Booking

Dataset statistics

Number of variables	31
Number of observations	206593
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	58.5 MiB
Average record size in memory	296.9 B

Variable types

Categorical	12
Numeric	19

Alerts

`id` has a high cardinality: 206593 distinct values	High cardinality
`first_browser` has a high cardinality: 52 distinct values	High cardinality
`signup_flow` is highly overall correlated with `signup_app`	High correlation
`days_from_first_active_untill_booking` is highly overall correlated with `days_from_account_created_untill_first_booking` and 4 other fields	High correlation
`days_from_account_created_untill_first_booking` is highly overall correlated with `days_from_first_active_untill_booking` and 4 other fields	High correlation
`year_first_active` is highly overall correlated with `year_account_created`	High correlation
`month_first_active` is highly overall correlated with `week_of_year_first_active` and 2 other fields	High correlation
`day_first_active` is highly overall correlated with `day_account_created`	High correlation
`day_of_week__first_active` is highly overall correlated with `day_of_week_account_created`	High correlation
`week_of_year_first_active` is highly overall correlated with `month_first_active` and 2 other fields	High correlation
`year_first_booking` is highly overall correlated with `days_from_first_active_untill_booking` and 4 other fields	High correlation
`month_first_booking` is highly overall correlated with `week_of_year_first_booking`	High correlation
`day_first_booking` is highly overall correlated with `days_from_first_active_untill_booking` and 3 other fields	High correlation
`day_of_week_first_booking` is highly overall correlated with `days_from_first_active_untill_booking` and 3 other fields	High correlation
`week_of_year_first_booking` is highly overall correlated with `month_first_booking`	High correlation
`month_account_created` is highly overall correlated with `month_first_active` and 2 other fields	High correlation
`day_account_created` is highly overall correlated with `day_first_active`	High correlation
`day_of_week_account_created` is highly overall correlated with `day_of_week__first_active`	High correlation
`week_of_year_account_created` is highly overall correlated with `month_first_active` and 2 other fields	High correlation
`affiliate_channel` is highly overall correlated with `affiliate_provider`	High correlation
`affiliate_provider` is highly overall correlated with `affiliate_channel`	High correlation
`signup_app` is highly overall correlated with `signup_flow` and 2 other fields	High correlation
`first_device_type` is highly overall correlated with `signup_app` and 1 other fields	High correlation
`first_browser` is highly overall correlated with `signup_app` and 1 other fields	High correlation
`year_account_created` is highly overall correlated with `days_from_first_active_untill_booking` and 3 other fields	High correlation
`language` is highly imbalanced (93.0%)	Imbalance
`affiliate_provider` is highly imbalanced (63.5%)	Imbalance
`signup_app` is highly imbalanced (61.3%)	Imbalance
`first_browser` is highly imbalanced (55.2%)	Imbalance
`country_destination` is highly imbalanced (52.9%)	Imbalance
`days_from_first_active_untill_account_created` is highly skewed (γ1 = 69.29642597)	Skewed
`id` is uniformly distributed	Uniform
`id` has unique values	Unique
`signup_flow` has 162557 (78.7%) zeros	Zeros
`days_from_first_active_untill_booking` has 20738 (10.0%) zeros	Zeros
`days_from_first_active_untill_account_created` has 206421 (99.9%) zeros	Zeros
`days_from_account_created_untill_first_booking` has 20741 (10.0%) zeros	Zeros
`day_of_week__first_active` has 31837 (15.4%) zeros	Zeros
`day_of_week_first_booking` has 132217 (64.0%) zeros	Zeros
`day_of_week_account_created` has 31830 (15.4%) zeros	Zeros

Reproduction

Analysis started	2023-04-10 02:41:21.295426
Analysis finished	2023-04-10 02:42:47.905242
Duration	1 minute and 26.61 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

id
Categorical

HIGH CARDINALITY UNIFORM UNIQUE

Distinct	206593
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

gxn3p5htnn	1
rioo9za4y8	1
oypwb8dpjq	1
rfbi1jdtsi	1
1n4g6rkyaj	1
Other values (206588)	206588

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	2065930
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	206593 ?
Unique (%)	100.0%

Sample

1st row	gxn3p5htnn
2nd row	820tgsjxq7
3rd row	4ft3gnwmtx
4th row	bjjt8pjhuk
5th row	87mebub9p4

Common Values

Value	Count	Frequency (%)
gxn3p5htnn	1	< 0.1%
rioo9za4y8	1	< 0.1%
oypwb8dpjq	1	< 0.1%
rfbi1jdtsi	1	< 0.1%
1n4g6rkyaj	1	< 0.1%
todvt5z6pw	1	< 0.1%
1w4hlsh371	1	< 0.1%
wq51bf02mm	1	< 0.1%
qg0niicmf2	1	< 0.1%
iw6a03tix5	1	< 0.1%
Other values (206583)	206583	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
gxn3p5htnn	1	< 0.1%
yuuqmid2rp	1	< 0.1%
cheova4spt	1	< 0.1%
hql77nu2lk	1	< 0.1%
4ft3gnwmtx	1	< 0.1%
bjjt8pjhuk	1	< 0.1%
87mebub9p4	1	< 0.1%
osr2jwljor	1	< 0.1%
lsw9q7uk0j	1	< 0.1%
0d01nltbrs	1	< 0.1%
Other values (206583)	206583	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
t	57855	2.8%
h	57719	2.8%
y	57712	2.8%
o	57682	2.8%
f	57593	2.8%
4	57586	2.8%
1	57560	2.8%
b	57558	2.8%
j	57550	2.8%
i	57525	2.8%
Other values (26)	1489590	72.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1492613	72.2%
Decimal Number	573317	27.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	57855	3.9%
h	57719	3.9%
y	57712	3.9%
o	57682	3.9%
f	57593	3.9%
b	57558	3.9%
j	57550	3.9%
i	57525	3.9%
w	57514	3.9%
a	57500	3.9%
Other values (16)	916405	61.4%

Decimal Number

Value	Count	Frequency (%)
4	57586	10.0%
1	57560	10.0%
2	57493	10.0%
7	57460	10.0%
3	57364	10.0%
8	57349	10.0%
9	57336	10.0%
0	57106	10.0%
5	57052	10.0%
6	57011	9.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1492613	72.2%
Common	573317	27.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	57855	3.9%
h	57719	3.9%
y	57712	3.9%
o	57682	3.9%
f	57593	3.9%
b	57558	3.9%
j	57550	3.9%
i	57525	3.9%
w	57514	3.9%
a	57500	3.9%
Other values (16)	916405	61.4%

Common

Value	Count	Frequency (%)
4	57586	10.0%
1	57560	10.0%
2	57493	10.0%
7	57460	10.0%
3	57364	10.0%
8	57349	10.0%
9	57336	10.0%
0	57106	10.0%
5	57052	10.0%
6	57011	9.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2065930	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	57855	2.8%
h	57719	2.8%
y	57712	2.8%
o	57682	2.8%
f	57593	2.8%
4	57586	2.8%
1	57560	2.8%
b	57558	2.8%
j	57550	2.8%
i	57525	2.8%
Other values (26)	1489590	72.1%

gender
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

-unknown-	91706
FEMALE	61520
MALE	53092
OTHER	275

Length

Max length	9
Median length	6
Mean length	6.8163829
Min length	4

Characters and Unicode

Total characters	1408217
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	-unknown-
2nd row	MALE
3rd row	FEMALE
4th row	FEMALE
5th row	-unknown-

Common Values

Value	Count	Frequency (%)
-unknown-	91706	44.4%
FEMALE	61520	29.8%
MALE	53092	25.7%
OTHER	275	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
unknown	91706	44.4%
female	61520	29.8%
male	53092	25.7%
other	275	0.1%

Most occurring characters

Value	Count	Frequency (%)
n	275118	19.5%
-	183412	13.0%
E	176407	12.5%
M	114612	8.1%
A	114612	8.1%
L	114612	8.1%
u	91706	6.5%
k	91706	6.5%
o	91706	6.5%
w	91706	6.5%
Other values (5)	62620	4.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	641942	45.6%
Uppercase Letter	582863	41.4%
Dash Punctuation	183412	13.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	176407	30.3%
M	114612	19.7%
A	114612	19.7%
L	114612	19.7%
F	61520	10.6%
O	275	< 0.1%
T	275	< 0.1%
H	275	< 0.1%
R	275	< 0.1%

Lowercase Letter

Value	Count	Frequency (%)
n	275118	42.9%
u	91706	14.3%
k	91706	14.3%
o	91706	14.3%
w	91706	14.3%

Dash Punctuation

Value	Count	Frequency (%)
-	183412	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1224805	87.0%
Common	183412	13.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
n	275118	22.5%
E	176407	14.4%
M	114612	9.4%
A	114612	9.4%
L	114612	9.4%
u	91706	7.5%
k	91706	7.5%
o	91706	7.5%
w	91706	7.5%
F	61520	5.0%
Other values (4)	1100	0.1%

Common

Value	Count	Frequency (%)
-	183412	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1408217	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
n	275118	19.5%
-	183412	13.0%
E	176407	12.5%
M	114612	8.1%
A	114612	8.1%
L	114612	8.1%
u	91706	6.5%
k	91706	6.5%
o	91706	6.5%
w	91706	6.5%
Other values (5)	62620	4.4%

age
Real number (ℝ)

Distinct	99
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	42.117424

Minimum	16
Maximum	115
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	16
5-th percentile	24
Q1	32
median	49
Q3	49
95-th percentile	57
Maximum	115
Range	99
Interquartile range (IQR)	17

Descriptive statistics

Standard deviation	12.156497
Coefficient of variation (CV)	0.28863344
Kurtosis	4.6261166
Mean	42.117424
Median Absolute Deviation (MAD)	6
Skewness	1.0019742
Sum	8701165
Variance	147.78042
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
49	85257	41.3%
30	6039	2.9%
31	5935	2.9%
29	5894	2.9%
28	5862	2.8%
32	5763	2.8%
27	5671	2.7%
33	5455	2.6%
26	4960	2.4%
34	4940	2.4%
Other values (89)	70817	34.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
16	26	< 0.1%
17	64	< 0.1%
18	665	0.3%
19	1097	0.5%
20	533	0.3%
21	969	0.5%
22	1679	0.8%
23	2424	1.2%
24	3173	1.5%
25	4405	2.1%

Value	Count	Frequency (%)
115	12	< 0.1%
113	4	< 0.1%
112	1	< 0.1%
111	2	< 0.1%
110	188	0.1%
109	31	< 0.1%
108	15	< 0.1%
107	23	< 0.1%
106	17	< 0.1%
105	1127	0.5%

signup_method
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

basic	147635
facebook	58412
google	546

Length

Max length	8
Median length	5
Mean length	5.8508614
Min length	5

Characters and Unicode

Total characters	1208747
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	facebook
2nd row	facebook
3rd row	basic
4th row	facebook
5th row	basic

Common Values

Value	Count	Frequency (%)
basic	147635	71.5%
facebook	58412	28.3%
google	546	0.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
basic	147635	71.5%
facebook	58412	28.3%
google	546	0.3%

Most occurring characters

Value	Count	Frequency (%)
b	206047	17.0%
a	206047	17.0%
c	206047	17.0%
s	147635	12.2%
i	147635	12.2%
o	117916	9.8%
e	58958	4.9%
f	58412	4.8%
k	58412	4.8%
g	1092	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1208747	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
b	206047	17.0%
a	206047	17.0%
c	206047	17.0%
s	147635	12.2%
i	147635	12.2%
o	117916	9.8%
e	58958	4.9%
f	58412	4.8%
k	58412	4.8%
g	1092	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1208747	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
b	206047	17.0%
a	206047	17.0%
c	206047	17.0%
s	147635	12.2%
i	147635	12.2%
o	117916	9.8%
e	58958	4.9%
f	58412	4.8%
k	58412	4.8%
g	1092	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1208747	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
b	206047	17.0%
a	206047	17.0%
c	206047	17.0%
s	147635	12.2%
i	147635	12.2%
o	117916	9.8%
e	58958	4.9%
f	58412	4.8%
k	58412	4.8%
g	1092	0.1%

signup_flow
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	17
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.1569463

Minimum	0
Maximum	25
Zeros	162557
Zeros (%)	78.7%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	25
Maximum	25
Range	25
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	7.5506836
Coefficient of variation (CV)	2.3917682
Kurtosis	3.5516157
Mean	3.1569463
Median Absolute Deviation (MAD)	0
Skewness	2.2837836
Sum	652203
Variance	57.012823
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	162557	78.7%
25	13724	6.6%
12	8897	4.3%
3	7550	3.7%
2	5522	2.7%
24	3975	1.9%
23	2793	1.4%
1	837	0.4%
6	240	0.1%
8	237	0.1%
Other values (7)	261	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	162557	78.7%
1	837	0.4%
2	5522	2.7%
3	7550	3.7%
4	1	< 0.1%
5	31	< 0.1%
6	240	0.1%
8	237	0.1%
10	2	< 0.1%
12	8897	4.3%

Value	Count	Frequency (%)
25	13724	6.6%
24	3975	1.9%
23	2793	1.4%
21	195	0.1%
20	14	< 0.1%
16	9	< 0.1%
15	9	< 0.1%
12	8897	4.3%
10	2	< 0.1%
8	237	0.1%

language
Categorical

Distinct	25
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

en	199636
zh	1599
fr	1146
es	888
ko	720
Other values (20)	2604

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	413186
Distinct characters	19
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	en
2nd row	en
3rd row	en
4th row	en
5th row	en

Common Values

Value	Count	Frequency (%)
en	199636	96.6%
zh	1599	0.8%
fr	1146	0.6%
es	888	0.4%
ko	720	0.3%
de	715	0.3%
it	489	0.2%
ru	378	0.2%
pt	234	0.1%
ja	224	0.1%
Other values (15)	564	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
en	199636	96.6%
zh	1599	0.8%
fr	1146	0.6%
es	888	0.4%
ko	720	0.3%
de	715	0.3%
it	489	0.2%
ru	378	0.2%
pt	234	0.1%
ja	224	0.1%
Other values (15)	564	0.3%

Most occurring characters

Value	Count	Frequency (%)
e	201263	48.7%
n	199760	48.3%
h	1641	0.4%
z	1599	0.4%
r	1589	0.4%
f	1160	0.3%
s	1046	0.3%
t	809	0.2%
d	795	0.2%
o	750	0.2%
Other values (9)	2774	0.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	413186	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	201263	48.7%
n	199760	48.3%
h	1641	0.4%
z	1599	0.4%
r	1589	0.4%
f	1160	0.3%
s	1046	0.3%
t	809	0.2%
d	795	0.2%
o	750	0.2%
Other values (9)	2774	0.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	413186	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	201263	48.7%
n	199760	48.3%
h	1641	0.4%
z	1599	0.4%
r	1589	0.4%
f	1160	0.3%
s	1046	0.3%
t	809	0.2%
d	795	0.2%
o	750	0.2%
Other values (9)	2774	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	413186	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	201263	48.7%
n	199760	48.3%
h	1641	0.4%
z	1599	0.4%
r	1589	0.4%
f	1160	0.3%
s	1046	0.3%
t	809	0.2%
d	795	0.2%
o	750	0.2%
Other values (9)	2774	0.7%

affiliate_channel
Categorical

Distinct	8
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

direct	133678
sem-brand	25681
sem-non-brand	17949
seo	8420
other	8296
Other values (3)	12569

Length

Max length	13
Median length	6
Mean length	6.7501077
Min length	3

Characters and Unicode

Total characters	1394525
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	direct
2nd row	seo
3rd row	direct
4th row	direct
5th row	direct

Common Values

Value	Count	Frequency (%)
direct	133678	64.7%
sem-brand	25681	12.4%
sem-non-brand	17949	8.7%
seo	8420	4.1%
other	8296	4.0%
api	7736	3.7%
content	3780	1.8%
remarketing	1053	0.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
direct	133678	64.7%
sem-brand	25681	12.4%
sem-non-brand	17949	8.7%
seo	8420	4.1%
other	8296	4.0%
api	7736	3.7%
content	3780	1.8%
remarketing	1053	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	199910	14.3%
r	187710	13.5%
d	177308	12.7%
t	150587	10.8%
i	142467	10.2%
c	137458	9.9%
n	88141	6.3%
-	61579	4.4%
a	52419	3.8%
s	52050	3.7%
Other values (7)	144896	10.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1332946	95.6%
Dash Punctuation	61579	4.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	199910	15.0%
r	187710	14.1%
d	177308	13.3%
t	150587	11.3%
i	142467	10.7%
c	137458	10.3%
n	88141	6.6%
a	52419	3.9%
s	52050	3.9%
m	44683	3.4%
Other values (6)	100213	7.5%

Dash Punctuation

Value	Count	Frequency (%)
-	61579	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1332946	95.6%
Common	61579	4.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	199910	15.0%
r	187710	14.1%
d	177308	13.3%
t	150587	11.3%
i	142467	10.7%
c	137458	10.3%
n	88141	6.6%
a	52419	3.9%
s	52050	3.9%
m	44683	3.4%
Other values (6)	100213	7.5%

Common

Value	Count	Frequency (%)
-	61579	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1394525	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	199910	14.3%
r	187710	13.5%
d	177308	12.7%
t	150587	10.8%
i	142467	10.2%
c	137458	9.9%
n	88141	6.3%
-	61579	4.4%
a	52419	3.8%
s	52050	3.7%
Other values (7)	144896	10.4%

affiliate_provider
Categorical

HIGH CORRELATION IMBALANCE

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

direct	133438
google	50252
other	11867
craigslist	2964
bing	2253
Other values (13)	5819

Length

Max length	19
Median length	6
Mean length	6.0352335
Min length	3

Characters and Unicode

Total characters	1246837
Distinct characters	24
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	direct
2nd row	google
3rd row	direct
4th row	direct
5th row	direct

Common Values

Value	Count	Frequency (%)
direct	133438	64.6%
google	50252	24.3%
other	11867	5.7%
craigslist	2964	1.4%
bing	2253	1.1%
facebook	2196	1.1%
padmapper	766	0.4%
vast	748	0.4%
facebook-open-graph	545	0.3%
yahoo	495	0.2%
Other values (8)	1069	0.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
direct	133438	64.6%
google	50252	24.3%
other	11867	5.7%
craigslist	2964	1.4%
bing	2253	1.1%
facebook	2196	1.1%
padmapper	766	0.4%
vast	748	0.4%
facebook-open-graph	545	0.3%
yahoo	495	0.2%
Other values (8)	1069	0.5%

Most occurring characters

Value	Count	Frequency (%)
e	200698	16.1%
r	149795	12.0%
t	149527	12.0%
i	141974	11.4%
c	139143	11.2%
d	134251	10.8%
o	119388	9.6%
g	106881	8.6%
l	53379	4.3%
h	12907	1.0%
Other values (14)	38894	3.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1245584	99.9%
Dash Punctuation	1253	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	200698	16.1%
r	149795	12.0%
t	149527	12.0%
i	141974	11.4%
c	139143	11.2%
d	134251	10.8%
o	119388	9.6%
g	106881	8.6%
l	53379	4.3%
h	12907	1.0%
Other values (13)	37641	3.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1253	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1245584	99.9%
Common	1253	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	200698	16.1%
r	149795	12.0%
t	149527	12.0%
i	141974	11.4%
c	139143	11.2%
d	134251	10.8%
o	119388	9.6%
g	106881	8.6%
l	53379	4.3%
h	12907	1.0%
Other values (13)	37641	3.0%

Common

Value	Count	Frequency (%)
-	1253	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1246837	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	200698	16.1%
r	149795	12.0%
t	149527	12.0%
i	141974	11.4%
c	139143	11.2%
d	134251	10.8%
o	119388	9.6%
g	106881	8.6%
l	53379	4.3%
h	12907	1.0%
Other values (14)	38894	3.1%

first_affiliate_tracked
Categorical

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

untracked	108838
linked	46084
omg	43830
tracked-other	6123
product	1545
Other values (2)	173

Length

Max length	13
Median length	9
Mean length	7.1614576
Min length	3

Characters and Unicode

Total characters	1479507
Distinct characters	19
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	untracked
2nd row	untracked
3rd row	untracked
4th row	untracked
5th row	untracked

Common Values

Value	Count	Frequency (%)
untracked	108838	52.7%
linked	46084	22.3%
omg	43830	21.2%
tracked-other	6123	3.0%
product	1545	0.7%
marketing	139	0.1%
local ops	34	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
untracked	108838	52.7%
linked	46084	22.3%
omg	43830	21.2%
tracked-other	6123	3.0%
product	1545	0.7%
marketing	139	0.1%
local	34	< 0.1%
ops	34	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
e	167307	11.3%
d	162590	11.0%
k	161184	10.9%
n	155061	10.5%
t	122768	8.3%
r	122768	8.3%
c	116540	7.9%
a	115134	7.8%
u	110383	7.5%
o	51566	3.5%
Other values (9)	194206	13.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1473350	99.6%
Dash Punctuation	6123	0.4%
Space Separator	34	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	167307	11.4%
d	162590	11.0%
k	161184	10.9%
n	155061	10.5%
t	122768	8.3%
r	122768	8.3%
c	116540	7.9%
a	115134	7.8%
u	110383	7.5%
o	51566	3.5%
Other values (7)	188049	12.8%

Dash Punctuation

Value	Count	Frequency (%)
-	6123	100.0%

Space Separator

Value	Count	Frequency (%)
	34	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1473350	99.6%
Common	6157	0.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	167307	11.4%
d	162590	11.0%
k	161184	10.9%
n	155061	10.5%
t	122768	8.3%
r	122768	8.3%
c	116540	7.9%
a	115134	7.8%
u	110383	7.5%
o	51566	3.5%
Other values (7)	188049	12.8%

Common

Value	Count	Frequency (%)
-	6123	99.4%
	34	0.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1479507	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	167307	11.3%
d	162590	11.0%
k	161184	10.9%
n	155061	10.5%
t	122768	8.3%
r	122768	8.3%
c	116540	7.9%
a	115134	7.8%
u	110383	7.5%
o	51566	3.5%
Other values (9)	194206	13.1%

signup_app
Categorical

HIGH CORRELATION IMBALANCE

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Web	177591
iOS	17852
Moweb	5771
Android	5379

Length

Max length	7
Median length	3
Mean length	3.1600151
Min length	3

Characters and Unicode

Total characters	652837
Distinct characters	13
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Web
2nd row	Web
3rd row	Web
4th row	Web
5th row	Web

Common Values

Value	Count	Frequency (%)
Web	177591	86.0%
iOS	17852	8.6%
Moweb	5771	2.8%
Android	5379	2.6%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
web	177591	86.0%
ios	17852	8.6%
moweb	5771	2.8%
android	5379	2.6%

Most occurring characters

Value	Count	Frequency (%)
e	183362	28.1%
b	183362	28.1%
W	177591	27.2%
i	23231	3.6%
O	17852	2.7%
S	17852	2.7%
o	11150	1.7%
d	10758	1.6%
M	5771	0.9%
w	5771	0.9%
Other values (3)	16137	2.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	428392	65.6%
Uppercase Letter	224445	34.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	183362	42.8%
b	183362	42.8%
i	23231	5.4%
o	11150	2.6%
d	10758	2.5%
w	5771	1.3%
n	5379	1.3%
r	5379	1.3%

Uppercase Letter

Value	Count	Frequency (%)
W	177591	79.1%
O	17852	8.0%
S	17852	8.0%
M	5771	2.6%
A	5379	2.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	652837	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	183362	28.1%
b	183362	28.1%
W	177591	27.2%
i	23231	3.6%
O	17852	2.7%
S	17852	2.7%
o	11150	1.7%
d	10758	1.6%
M	5771	0.9%
w	5771	0.9%
Other values (3)	16137	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	652837	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	183362	28.1%
b	183362	28.1%
W	177591	27.2%
i	23231	3.6%
O	17852	2.7%
S	17852	2.7%
o	11150	1.7%
d	10758	1.6%
M	5771	0.9%
w	5771	0.9%
Other values (3)	16137	2.5%

first_device_type
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Mac Desktop	89255
Windows Desktop	72410
iPhone	20712
iPad	14281
Other/Unknown	4591
Other values (4)	5344

Length

Max length	18
Median length	15
Mean length	11.532617
Min length	4

Characters and Unicode

Total characters	2382558
Distinct characters	30
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Mac Desktop
2nd row	Mac Desktop
3rd row	Windows Desktop
4th row	Mac Desktop
5th row	Mac Desktop

Common Values

Value	Count	Frequency (%)
Mac Desktop	89255	43.2%
Windows Desktop	72410	35.0%
iPhone	20712	10.0%
iPad	14281	6.9%
Other/Unknown	4591	2.2%
Android Phone	2788	1.3%
Android Tablet	1285	0.6%
Desktop (Other)	1196	0.6%
SmartPhone (Other)	75	< 0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
desktop	162861	43.6%
mac	89255	23.9%
windows	72410	19.4%
iphone	20712	5.5%
ipad	14281	3.8%
other/unknown	4591	1.2%
android	4073	1.1%
phone	2788	0.7%
tablet	1285	0.3%
other	1271	0.3%

Most occurring characters

Value	Count	Frequency (%)
o	267510	11.2%
s	235271	9.9%
e	193583	8.1%
t	170083	7.1%
k	167452	7.0%
	167009	7.0%
D	162861	6.8%
p	162861	6.8%
n	113831	4.8%
i	111476	4.7%
Other values (20)	630621	26.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1830148	76.8%
Uppercase Letter	378268	15.9%
Space Separator	167009	7.0%
Other Punctuation	4591	0.2%
Open Punctuation	1271	0.1%
Close Punctuation	1271	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	267510	14.6%
s	235271	12.9%
e	193583	10.6%
t	170083	9.3%
k	167452	9.1%
p	162861	8.9%
n	113831	6.2%
i	111476	6.1%
a	104896	5.7%
d	94837	5.2%
Other values (7)	208348	11.4%

Uppercase Letter

Value	Count	Frequency (%)
D	162861	43.1%
M	89255	23.6%
W	72410	19.1%
P	37856	10.0%
O	5862	1.5%
U	4591	1.2%
A	4073	1.1%
T	1285	0.3%
S	75	< 0.1%

Space Separator

Value	Count	Frequency (%)
	167009	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	4591	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1271	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1271	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2208416	92.7%
Common	174142	7.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	267510	12.1%
s	235271	10.7%
e	193583	8.8%
t	170083	7.7%
k	167452	7.6%
D	162861	7.4%
p	162861	7.4%
n	113831	5.2%
i	111476	5.0%
a	104896	4.7%
Other values (16)	518592	23.5%

Common

Value	Count	Frequency (%)
	167009	95.9%
/	4591	2.6%
(	1271	0.7%
)	1271	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2382558	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	267510	11.2%
s	235271	9.9%
e	193583	8.1%
t	170083	7.1%
k	167452	7.0%
	167009	7.0%
D	162861	6.8%
p	162861	6.8%
n	113831	4.8%
i	111476	4.7%
Other values (20)	630621	26.5%

first_browser
Categorical

HIGH CARDINALITY HIGH CORRELATION IMBALANCE

Distinct	52
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

Chrome	63620
Safari	44981
Firefox	33513
-unknown-	21166
IE	20970
Other values (47)	22343

Length

Max length	20
Median length	6
Mean length	6.8085027
Min length	2

Characters and Unicode

Total characters	1406589
Distinct characters	50
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	12 ?
Unique (%)	< 0.1%

Sample

1st row	Chrome
2nd row	Chrome
3rd row	IE
4th row	Firefox
5th row	Chrome

Common Values

Value	Count	Frequency (%)
Chrome	63620	30.8%
Safari	44981	21.8%
Firefox	33513	16.2%
-unknown-	21166	10.2%
IE	20970	10.2%
Mobile Safari	19195	9.3%
Chrome Mobile	1258	0.6%
Android Browser	844	0.4%
AOL Explorer	240	0.1%
Opera	187	0.1%
Other values (42)	619	0.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chrome	64878	28.4%
safari	64176	28.1%
firefox	33543	14.7%
unknown	21166	9.3%
ie	21006	9.2%
mobile	20521	9.0%
browser	907	0.4%
android	844	0.4%
explorer	273	0.1%
aol	240	0.1%
Other values (48)	799	0.3%

Most occurring characters

Value	Count	Frequency (%)
r	166259	11.8%
o	142522	10.1%
a	128752	9.2%
e	120588	8.6%
i	119405	8.5%
f	97719	6.9%
m	65051	4.6%
h	65000	4.6%
C	64982	4.6%
n	64472	4.6%
Other values (40)	371839	26.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1113623	79.2%
Uppercase Letter	228859	16.3%
Dash Punctuation	42332	3.0%
Space Separator	21760	1.5%
Other Punctuation	11	< 0.1%
Decimal Number	4	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	166259	14.9%
o	142522	12.8%
a	128752	11.6%
e	120588	10.8%
i	119405	10.7%
f	97719	8.8%
m	65051	5.8%
h	65000	5.8%
n	64472	5.8%
x	33881	3.0%
Other values (14)	109974	9.9%

Uppercase Letter

Value	Count	Frequency (%)
C	64982	28.4%
S	64378	28.1%
F	33561	14.7%
E	21281	9.3%
I	21037	9.2%
M	20657	9.0%
A	1125	0.5%
B	1039	0.5%
O	442	0.2%
L	240	0.1%
Other values (10)	117	0.1%

Decimal Number

Value	Count	Frequency (%)
0	2	50.0%
2	1	25.0%
7	1	25.0%

Dash Punctuation

Value	Count	Frequency (%)
-	42332	100.0%

Space Separator

Value	Count	Frequency (%)
	21760	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	11	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1342482	95.4%
Common	64107	4.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	166259	12.4%
o	142522	10.6%
a	128752	9.6%
e	120588	9.0%
i	119405	8.9%
f	97719	7.3%
m	65051	4.8%
h	65000	4.8%
C	64982	4.8%
n	64472	4.8%
Other values (34)	307732	22.9%

Common

Value	Count	Frequency (%)
-	42332	66.0%
	21760	33.9%
.	11	< 0.1%
0	2	< 0.1%
2	1	< 0.1%
7	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1406589	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	166259	11.8%
o	142522	10.1%
a	128752	9.2%
e	120588	8.6%
i	119405	8.5%
f	97719	6.9%
m	65051	4.6%
h	65000	4.6%
C	64982	4.6%
n	64472	4.6%
Other values (40)	371839	26.4%

country_destination
Categorical

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

NDF	119810
US	60800
other	9935
FR	4881
IT	2776
Other values (7)	8391

Length

Max length	5
Median length	3
Mean length	2.7242017
Min length	2

Characters and Unicode

Total characters	562801
Distinct characters	20
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	NDF
2nd row	NDF
3rd row	US
4th row	other
5th row	US

Common Values

Value	Count	Frequency (%)
NDF	119810	58.0%
US	60800	29.4%
other	9935	4.8%
FR	4881	2.4%
IT	2776	1.3%
GB	2285	1.1%
ES	2203	1.1%
CA	1385	0.7%
DE	1033	0.5%
NL	746	0.4%
Other values (2)	739	0.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ndf	119810	58.0%
us	60800	29.4%
other	9935	4.8%
fr	4881	2.4%
it	2776	1.3%
gb	2285	1.1%
es	2203	1.1%
ca	1385	0.7%
de	1033	0.5%
nl	746	0.4%
Other values (2)	739	0.4%

Most occurring characters

Value	Count	Frequency (%)
F	124691	22.2%
D	120843	21.5%
N	120556	21.4%
S	63003	11.2%
U	61326	10.9%
o	9935	1.8%
t	9935	1.8%
h	9935	1.8%
e	9935	1.8%
r	9935	1.8%
Other values (10)	22707	4.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	513126	91.2%
Lowercase Letter	49675	8.8%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	124691	24.3%
D	120843	23.6%
N	120556	23.5%
S	63003	12.3%
U	61326	12.0%
R	4881	1.0%
E	3236	0.6%
T	2989	0.6%
I	2776	0.5%
G	2285	0.4%
Other values (5)	6540	1.3%

Lowercase Letter

Value	Count	Frequency (%)
o	9935	20.0%
t	9935	20.0%
h	9935	20.0%
e	9935	20.0%
r	9935	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	562801	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	124691	22.2%
D	120843	21.5%
N	120556	21.4%
S	63003	11.2%
U	61326	10.9%
o	9935	1.8%
t	9935	1.8%
h	9935	1.8%
e	9935	1.8%
r	9935	1.8%
Other values (10)	22707	4.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	562801	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	124691	22.2%
D	120843	21.5%
N	120556	21.4%
S	63003	11.2%
U	61326	10.9%
o	9935	1.8%
t	9935	1.8%
h	9935	1.8%
e	9935	1.8%
r	9935	1.8%
Other values (10)	22707	4.0%

days_from_first_active_untill_booking
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1940
Distinct (%)	0.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	421.73604

Minimum	0
Maximum	2293
Zeros	20738
Zeros (%)	10.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	6
median	416
Q3	678
95-th percentile	1108
Maximum	2293
Range	2293
Interquartile range (IQR)	672

Descriptive statistics

Standard deviation	388.22993
Coefficient of variation (CV)	0.92055194
Kurtosis	-0.22795045
Mean	421.73604
Median Absolute Deviation (MAD)	374
Skewness	0.62869493
Sum	87127714
Variance	150722.48
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20738	10.0%
1	14288	6.9%
2	6307	3.1%
3	3894	1.9%
4	2845	1.4%
5	2193	1.1%
6	1735	0.8%
7	1611	0.8%
8	1275	0.6%
9	1024	0.5%
Other values (1930)	150683	72.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20738	10.0%
1	14288	6.9%
2	6307	3.1%
3	3894	1.9%
4	2845	1.4%
5	2193	1.1%
6	1735	0.8%
7	1611	0.8%
8	1275	0.6%
9	1024	0.5%

Value	Count	Frequency (%)
2293	1	< 0.1%
2228	1	< 0.1%
2001	2	< 0.1%
1999	1	< 0.1%
1995	2	< 0.1%
1994	1	< 0.1%
1992	1	< 0.1%
1991	3	< 0.1%
1990	2	< 0.1%
1982	1	< 0.1%

days_from_first_active_untill_account_created
Real number (ℝ)

SKEWED ZEROS

Distinct	142
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.23668275

Minimum	0
Maximum	1456
Zeros	206421
Zeros (%)	99.9%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1456
Range	1456
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.11225
Coefficient of variation (CV)	51.175041
Kurtosis	5699.5656
Mean	0.23668275
Median Absolute Deviation (MAD)	0
Skewness	69.296426
Sum	48897
Variance	146.70659
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	206421	99.9%
1	6	< 0.1%
6	4	< 0.1%
5	3	< 0.1%
29	3	< 0.1%
2	3	< 0.1%
7	3	< 0.1%
3	3	< 0.1%
103	2	< 0.1%
95	2	< 0.1%
Other values (132)	143	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	206421	99.9%
1	6	< 0.1%
2	3	< 0.1%
3	3	< 0.1%
4	2	< 0.1%
5	3	< 0.1%
6	4	< 0.1%
7	3	< 0.1%
9	2	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
1456	1	< 0.1%
1369	1	< 0.1%
1361	1	< 0.1%
1148	1	< 0.1%
1036	1	< 0.1%
1018	1	< 0.1%
1011	1	< 0.1%
998	1	< 0.1%
995	1	< 0.1%
882	1	< 0.1%

days_from_account_created_untill_first_booking
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1963
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	421.49936

Minimum	-349
Maximum	2001
Zeros	20741
Zeros (%)	10.0%
Negative	28
Negative (%)	< 0.1%
Memory size	3.2 MiB

Quantile statistics

Minimum	-349
5-th percentile	0
Q1	6
median	416
Q3	678
95-th percentile	1108
Maximum	2001
Range	2350
Interquartile range (IQR)	672

Descriptive statistics

Standard deviation	388.11799
Coefficient of variation (CV)	0.92080328
Kurtosis	-0.23235143
Mean	421.49936
Median Absolute Deviation (MAD)	374
Skewness	0.62763033
Sum	87078817
Variance	150635.58
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20741	10.0%
1	14289	6.9%
2	6309	3.1%
3	3897	1.9%
4	2845	1.4%
5	2197	1.1%
6	1738	0.8%
7	1611	0.8%
8	1276	0.6%
9	1022	0.5%
Other values (1953)	150668	72.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-349	1	< 0.1%
-347	1	< 0.1%
-338	1	< 0.1%
-308	1	< 0.1%
-298	1	< 0.1%
-295	1	< 0.1%
-269	1	< 0.1%
-261	1	< 0.1%
-208	1	< 0.1%
-167	1	< 0.1%

Value	Count	Frequency (%)
2001	2	< 0.1%
1999	1	< 0.1%
1995	2	< 0.1%
1994	1	< 0.1%
1992	1	< 0.1%
1991	3	< 0.1%
1990	2	< 0.1%
1982	1	< 0.1%
1980	1	< 0.1%
1979	1	< 0.1%

year_first_active
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2013.0627

Minimum	2009
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	2009
5-th percentile	2011
Q1	2013
median	2013
Q3	2014
95-th percentile	2014
Maximum	2014
Range	5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.90115082
Coefficient of variation (CV)	0.00044765164
Kurtosis	0.305154
Mean	2013.0627
Median Absolute Deviation (MAD)	1
Skewness	-0.80843674
Sum	4.1588466 × 10⁸
Variance	0.81207281
Monotonicity	Increasing

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2013	81841	39.6%
2014	75496	36.5%
2012	37950	18.4%
2011	9331	4.5%
2010	1970	1.0%
2009	5	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	5	< 0.1%
2010	1970	1.0%
2011	9331	4.5%
2012	37950	18.4%
2013	81841	39.6%
2014	75496	36.5%

Value	Count	Frequency (%)
2014	75496	36.5%
2013	81841	39.6%
2012	37950	18.4%
2011	9331	4.5%
2010	1970	1.0%
2009	5	< 0.1%

month_first_active
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.016956

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.2214541
Coefficient of variation (CV)	0.53539599
Kurtosis	-0.95288265
Mean	6.016956
Median Absolute Deviation (MAD)	3
Skewness	0.2529472
Sum	1243061
Variance	10.377767
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	27033	13.1%
5	25525	12.4%
4	21333	10.3%
3	19482	9.4%
1	16768	8.1%
2	15853	7.7%
9	14774	7.2%
8	14061	6.8%
7	13410	6.5%
10	13031	6.3%
Other values (2)	25323	12.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16768	8.1%
2	15853	7.7%
3	19482	9.4%
4	21333	10.3%
5	25525	12.4%
6	27033	13.1%
7	13410	6.5%
8	14061	6.8%
9	14774	7.2%
10	13031	6.3%

Value	Count	Frequency (%)
12	12799	6.2%
11	12524	6.1%
10	13031	6.3%
9	14774	7.2%
8	14061	6.8%
7	13410	6.5%
6	27033	13.1%
5	25525	12.4%
4	21333	10.3%
3	19482	9.4%

day_first_active
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.872677

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7420428
Coefficient of variation (CV)	0.55076045
Kurtosis	-1.1874752
Mean	15.872677
Median Absolute Deviation (MAD)	8
Skewness	-0.011222017
Sum	3279184
Variance	76.423312
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	7182	3.5%
20	7014	3.4%
18	7010	3.4%
16	6988	3.4%
23	6988	3.4%
19	6956	3.4%
28	6915	3.3%
17	6908	3.3%
26	6908	3.3%
13	6889	3.3%
Other values (21)	136835	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5967	2.9%
2	6561	3.2%
3	6750	3.3%
4	6620	3.2%
5	6817	3.3%
6	6772	3.3%
7	6510	3.2%
8	6698	3.2%
9	6717	3.3%
10	6810	3.3%

Value	Count	Frequency (%)
31	3607	1.7%
30	6587	3.2%
29	6363	3.1%
28	6915	3.3%
27	6842	3.3%
26	6908	3.3%
25	6728	3.3%
24	7182	3.5%
23	6988	3.4%
22	6720	3.3%

day_of_week__first_active
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7620539

Minimum	0
Maximum	6
Zeros	31837
Zeros (%)	15.4%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.9442686
Coefficient of variation (CV)	0.70392132
Kurtosis	-1.1497729
Mean	2.7620539
Median Absolute Deviation (MAD)	2
Skewness	0.1677711
Sum	570621
Variance	3.7801805
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	33988	16.5%
2	33041	16.0%
0	31837	15.4%
3	31504	15.2%
4	28807	13.9%
6	23731	11.5%
5	23685	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	31837	15.4%
1	33988	16.5%
2	33041	16.0%
3	31504	15.2%
4	28807	13.9%
5	23685	11.5%
6	23731	11.5%

Value	Count	Frequency (%)
6	23731	11.5%
5	23685	11.5%
4	28807	13.9%
3	31504	15.2%
2	33041	16.0%
1	33988	16.5%
0	31837	15.4%

week_of_year_first_active
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.37389

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	13
median	23
Q3	36
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	13.95401
Coefficient of variation (CV)	0.57249827
Kurtosis	-0.94114835
Mean	24.37389
Median Absolute Deviation (MAD)	11
Skewness	0.25341813
Sum	5035475
Variance	194.71439
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	6779	3.3%
25	6426	3.1%
24	6164	3.0%
21	6116	3.0%
23	6062	2.9%
20	6057	2.9%
22	5602	2.7%
19	5490	2.7%
18	5433	2.6%
17	5309	2.6%
Other values (43)	147155	71.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3196	1.5%
2	3824	1.9%
3	4026	1.9%
4	3785	1.8%
5	3794	1.8%
6	3913	1.9%
7	3842	1.9%
8	4038	2.0%
9	4281	2.1%
10	4236	2.1%

Value	Count	Frequency (%)
53	3	< 0.1%
52	2671	1.3%
51	2784	1.3%
50	2890	1.4%
49	3170	1.5%
48	2807	1.4%
47	2890	1.4%
46	3068	1.5%
45	3066	1.5%
44	2745	1.3%

year_first_booking
Real number (ℝ)

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.1956

Minimum	2010
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	2010
5-th percentile	2012
Q1	2013
median	2015
Q3	2015
95-th percentile	2015
Maximum	2015
Range	5
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.1387295
Coefficient of variation (CV)	0.000565352
Kurtosis	0.78253442
Mean	2014.1956
Median Absolute Deviation (MAD)	0
Skewness	-1.2854707
Sum	4.161187 × 10⁸
Variance	1.2967049
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
2015	121581	58.9%
2014	32334	15.7%
2013	31083	15.0%
2012	15797	7.6%
2011	4690	2.3%
2010	1108	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2010	1108	0.5%
2011	4690	2.3%
2012	15797	7.6%
2013	31083	15.0%
2014	32334	15.7%
2015	121581	58.9%

Value	Count	Frequency (%)
2015	121581	58.9%
2014	32334	15.7%
2013	31083	15.0%
2012	15797	7.6%
2011	4690	2.3%
2010	1108	0.5%

month_first_booking
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.043593

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	6
median	6
Q3	6
95-th percentile	10
Maximum	12
Range	11
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	2.0591816
Coefficient of variation (CV)	0.34072143
Kurtosis	1.87404
Mean	6.043593
Median Absolute Deviation (MAD)	0
Skewness	0.38550344
Sum	1248564
Variance	4.2402291
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	130148	63.0%
5	10322	5.0%
4	8624	4.2%
3	8159	3.9%
7	7073	3.4%
8	6854	3.3%
2	6616	3.2%
9	6402	3.1%
1	6338	3.1%
10	6009	2.9%
Other values (2)	10048	4.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	6338	3.1%
2	6616	3.2%
3	8159	3.9%
4	8624	4.2%
5	10322	5.0%
6	130148	63.0%
7	7073	3.4%
8	6854	3.3%
9	6402	3.1%
10	6009	2.9%

Value	Count	Frequency (%)
12	4944	2.4%
11	5104	2.5%
10	6009	2.9%
9	6402	3.1%
8	6854	3.3%
7	7073	3.4%
6	130148	63.0%
5	10322	5.0%
4	8624	4.2%
3	8159	3.9%

day_first_booking
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	23.392312

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	4
Q1	18
median	29
Q3	29
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	8.6825814
Coefficient of variation (CV)	0.37117243
Kurtosis	0.13553141
Mean	23.392312
Median Absolute Deviation (MAD)	0
Skewness	-1.2661289
Sum	4832688
Variance	75.38722
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
29	122367	59.2%
10	3009	1.5%
17	2996	1.5%
11	2982	1.4%
16	2964	1.4%
13	2950	1.4%
15	2950	1.4%
5	2918	1.4%
12	2892	1.4%
3	2882	1.4%
Other values (21)	57683	27.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2690	1.3%
2	2807	1.4%
3	2882	1.4%
4	2784	1.3%
5	2918	1.4%
6	2876	1.4%
7	2863	1.4%
8	2882	1.4%
9	2848	1.4%
10	3009	1.5%

Value	Count	Frequency (%)
31	1526	0.7%
30	2650	1.3%
29	122367	59.2%
28	2809	1.4%
27	2698	1.3%
26	2757	1.3%
25	2805	1.4%
24	2824	1.4%
23	2793	1.4%
22	2860	1.4%

day_of_week_first_booking
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.1775907

Minimum	0
Maximum	6
Zeros	132217
Zeros (%)	64.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	5
Maximum	6
Range	6
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.8587813
Coefficient of variation (CV)	1.5784612
Kurtosis	0.48607844
Mean	1.1775907
Median Absolute Deviation (MAD)	0
Skewness	1.3647587
Sum	243282
Variance	3.4550678
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	132217	64.0%
2	14029	6.8%
1	13970	6.8%
3	13627	6.6%
4	12972	6.3%
5	10183	4.9%
6	9595	4.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	132217	64.0%
1	13970	6.8%
2	14029	6.8%
3	13627	6.6%
4	12972	6.3%
5	10183	4.9%
6	9595	4.6%

Value	Count	Frequency (%)
6	9595	4.6%
5	10183	4.9%
4	12972	6.3%
3	13627	6.6%
2	14029	6.8%
1	13970	6.8%
0	132217	64.0%

week_of_year_first_booking
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26.046705

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	7
Q1	27
median	27
Q3	27
95-th percentile	44
Maximum	53
Range	52
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.9866041
Coefficient of variation (CV)	0.34501884
Kurtosis	1.6636917
Mean	26.046705
Median Absolute Deviation (MAD)	0
Skewness	-0.13773093
Sum	5381067
Variance	80.759053
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27	121629	58.9%
26	2488	1.2%
24	2462	1.2%
21	2451	1.2%
20	2434	1.2%
25	2403	1.2%
23	2366	1.1%
18	2277	1.1%
19	2263	1.1%
22	2218	1.1%
Other values (43)	63602	30.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1092	0.5%
2	1438	0.7%
3	1717	0.8%
4	1401	0.7%
5	1444	0.7%
6	1590	0.8%
7	1719	0.8%
8	1672	0.8%
9	1748	0.8%
10	1840	0.9%

Value	Count	Frequency (%)
53	1	< 0.1%
52	915	0.4%
51	1130	0.5%
50	1172	0.6%
49	1249	0.6%
48	1121	0.5%
47	1118	0.5%
46	1191	0.6%
45	1354	0.7%
44	1188	0.6%

year_account_created
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.2 MiB

2013	81851
2014	75532
2012	37936
2011	9313
2010	1961

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	826372
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2010
2nd row	2011
3rd row	2010
4th row	2011
5th row	2010

Common Values

Value	Count	Frequency (%)
2013	81851	39.6%
2014	75532	36.6%
2012	37936	18.4%
2011	9313	4.5%
2010	1961	0.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2013	81851	39.6%
2014	75532	36.6%
2012	37936	18.4%
2011	9313	4.5%
2010	1961	0.9%

Most occurring characters

Value	Count	Frequency (%)
2	244529	29.6%
1	215906	26.1%
0	208554	25.2%
3	81851	9.9%
4	75532	9.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	826372	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	244529	29.6%
1	215906	26.1%
0	208554	25.2%
3	81851	9.9%
4	75532	9.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	826372	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	244529	29.6%
1	215906	26.1%
0	208554	25.2%
3	81851	9.9%
4	75532	9.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	826372	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	244529	29.6%
1	215906	26.1%
0	208554	25.2%
3	81851	9.9%
4	75532	9.1%

month_account_created
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.0169948

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	3
median	6
Q3	9
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	6

Descriptive statistics

Standard deviation	3.2216538
Coefficient of variation (CV)	0.53542572
Kurtosis	-0.95303482
Mean	6.0169948
Median Absolute Deviation (MAD)	3
Skewness	0.2528859
Sum	1243069
Variance	10.379053
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
6	27028	13.1%
5	25531	12.4%
4	21324	10.3%
3	19481	9.4%
1	16773	8.1%
2	15855	7.7%
9	14780	7.2%
8	14060	6.8%
7	13405	6.5%
10	13030	6.3%
Other values (2)	25326	12.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	16773	8.1%
2	15855	7.7%
3	19481	9.4%
4	21324	10.3%
5	25531	12.4%
6	27028	13.1%
7	13405	6.5%
8	14060	6.8%
9	14780	7.2%
10	13030	6.3%

Value	Count	Frequency (%)
12	12803	6.2%
11	12523	6.1%
10	13030	6.3%
9	14780	7.2%
8	14060	6.8%
7	13405	6.5%
6	27028	13.1%
5	25531	12.4%
4	21324	10.3%
3	19481	9.4%

day_account_created
Real number (ℝ)

Distinct	31
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.872953

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7425077
Coefficient of variation (CV)	0.55078017
Kurtosis	-1.187561
Mean	15.872953
Median Absolute Deviation (MAD)	8
Skewness	-0.011387796
Sum	3279241
Variance	76.431442
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
24	7183	3.5%
20	7018	3.4%
18	7009	3.4%
16	6994	3.4%
23	6990	3.4%
19	6955	3.4%
28	6921	3.4%
17	6904	3.3%
26	6904	3.3%
13	6883	3.3%
Other values (21)	136832	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5969	2.9%
2	6564	3.2%
3	6754	3.3%
4	6620	3.2%
5	6817	3.3%
6	6770	3.3%
7	6506	3.1%
8	6701	3.2%
9	6713	3.2%
10	6808	3.3%

Value	Count	Frequency (%)
31	3605	1.7%
30	6588	3.2%
29	6366	3.1%
28	6921	3.4%
27	6841	3.3%
26	6904	3.3%
25	6724	3.3%
24	7183	3.5%
23	6990	3.4%
22	6725	3.3%

day_of_week_account_created
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7621991

Minimum	0
Maximum	6
Zeros	31830
Zeros (%)	15.4%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	3
Q3	4
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.944269
Coefficient of variation (CV)	0.70388444
Kurtosis	-1.1498462
Mean	2.7621991
Median Absolute Deviation (MAD)	2
Skewness	0.16770178
Sum	570651
Variance	3.7801818
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	33992	16.5%
2	33040	16.0%
0	31830	15.4%
3	31499	15.2%
4	28811	13.9%
6	23733	11.5%
5	23688	11.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	31830	15.4%
1	33992	16.5%
2	33040	16.0%
3	31499	15.2%
4	28811	13.9%
5	23688	11.5%
6	23733	11.5%

Value	Count	Frequency (%)
6	23733	11.5%
5	23688	11.5%
4	28811	13.9%
3	31499	15.2%
2	33040	16.0%
1	33992	16.5%
0	31830	15.4%

week_of_year_account_created
Real number (ℝ)

Distinct	53
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	24.37418

Minimum	1
Maximum	53
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	3.2 MiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	13
median	23
Q3	36
95-th percentile	49
Maximum	53
Range	52
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	13.954891
Coefficient of variation (CV)	0.5725276
Kurtosis	-0.94130553
Mean	24.37418
Median Absolute Deviation (MAD)	11
Skewness	0.25335698
Sum	5035535
Variance	194.73898
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
26	6777	3.3%
25	6426	3.1%
24	6164	3.0%
21	6116	3.0%
23	6061	2.9%
20	6057	2.9%
22	5606	2.7%
19	5486	2.7%
18	5441	2.6%
17	5308	2.6%
Other values (43)	147151	71.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	3198	1.5%
2	3826	1.9%
3	4025	1.9%
4	3785	1.8%
5	3795	1.8%
6	3913	1.9%
7	3844	1.9%
8	4038	2.0%
9	4282	2.1%
10	4236	2.1%

Value	Count	Frequency (%)
53	3	< 0.1%
52	2671	1.3%
51	2785	1.3%
50	2891	1.4%
49	3173	1.5%
48	2806	1.4%
47	2893	1.4%
46	3063	1.5%
45	3068	1.5%
44	2745	1.3%

Auto

Heatmap
Table

	age	signup_flow	days_from_first_active_untill_booking	days_from_first_active_untill_account_created	days_from_account_created_untill_first_booking	year_first_active	month_first_active	day_first_active	day_of_week__first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created	gender	signup_method	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	year_account_created
age	1.000	-0.008	0.161	-0.002	0.161	0.004	0.009	-0.001	0.020	0.009	0.187	0.006	0.182	-0.184	0.037	0.009	-0.001	0.021	0.009	0.384	0.308	0.029	0.052	0.046	0.043	0.055	0.049	0.065	0.103	0.063
signup_flow	-0.008	1.000	-0.013	0.004	-0.013	-0.006	-0.001	0.011	0.034	-0.003	0.007	0.031	0.029	-0.028	0.031	-0.001	0.011	0.034	-0.004	0.098	0.236	0.014	0.365	0.267	0.109	0.569	0.282	0.258	0.044	0.221
days_from_first_active_untill_booking	0.161	-0.013	1.000	0.006	1.000	-0.242	0.083	-0.006	-0.004	0.080	0.826	0.050	0.718	-0.731	0.168	0.083	-0.006	-0.004	0.080	0.141	0.102	0.018	0.095	0.090	0.048	0.150	0.098	0.085	0.315	0.598
days_from_first_active_untill_account_created	-0.002	0.004	0.006	1.000	-0.013	-0.032	0.005	0.000	-0.002	0.005	-0.019	0.006	-0.015	0.017	0.004	0.005	0.001	0.000	0.006	0.022	0.000	0.000	0.000	0.002	0.000	0.003	0.000	0.003	0.003	0.011
days_from_account_created_untill_first_booking	0.161	-0.013	1.000	-0.013	1.000	-0.241	0.083	-0.006	-0.004	0.080	0.827	0.050	0.718	-0.731	0.168	0.083	-0.006	-0.004	0.080	0.157	0.091	0.018	0.084	0.093	0.054	0.161	0.089	0.086	0.332	0.609
year_first_active	0.004	-0.006	-0.242	-0.032	-0.241	1.000	-0.495	0.003	0.013	-0.481	0.265	-0.226	0.062	-0.068	-0.222	-0.495	0.003	0.013	-0.481	0.103	0.086	0.016	0.112	0.140	0.060	0.146	0.096	0.100	0.046	0.998
month_first_active	0.009	-0.001	0.083	0.005	0.083	-0.495	1.000	-0.012	-0.011	0.975	-0.062	0.440	0.009	-0.006	0.417	0.999	-0.012	-0.011	0.975	0.034	0.054	0.009	0.066	0.063	0.037	0.073	0.063	0.042	0.017	0.307
day_first_active	-0.001	0.011	-0.006	0.000	-0.006	0.003	-0.012	1.000	-0.002	0.057	0.012	-0.002	0.144	-0.005	0.005	-0.012	0.999	-0.002	0.057	0.004	0.006	0.000	0.008	0.017	0.015	0.017	0.009	0.009	0.004	0.015
day_of_week__first_active	0.020	0.034	-0.004	-0.002	-0.004	0.013	-0.011	-0.002	1.000	-0.015	0.002	-0.004	-0.001	0.053	-0.005	-0.011	-0.002	0.999	-0.015	0.003	0.005	0.006	0.012	0.013	0.008	0.030	0.031	0.030	0.008	0.010
week_of_year_first_active	0.009	-0.003	0.080	0.005	0.080	-0.481	0.975	0.057	-0.015	1.000	-0.060	0.439	0.018	-0.006	0.422	0.975	0.057	-0.015	0.999	0.031	0.049	0.010	0.063	0.062	0.038	0.067	0.059	0.039	0.017	0.297
year_first_booking	0.187	0.007	0.826	-0.019	0.827	0.265	-0.062	0.012	0.002	-0.060	1.000	-0.092	0.789	-0.806	0.037	-0.062	0.012	0.002	-0.060	0.126	0.042	0.019	0.086	0.099	0.042	0.086	0.065	0.072	0.440	0.644
month_first_booking	0.006	0.031	0.050	0.006	0.050	-0.226	0.440	-0.002	-0.004	0.439	-0.092	1.000	0.033	-0.038	0.947	0.440	-0.002	-0.004	0.439	0.115	0.026	0.012	0.036	0.025	0.031	0.055	0.042	0.040	0.302	0.136
day_first_booking	0.182	0.029	0.718	-0.015	0.718	0.062	0.009	0.144	-0.001	0.018	0.789	0.033	1.000	-0.719	0.159	0.008	0.144	-0.001	0.018	0.116	0.023	0.012	0.033	0.020	0.023	0.054	0.040	0.039	0.312	0.044
day_of_week_first_booking	-0.184	-0.028	-0.731	0.017	-0.731	-0.068	-0.006	-0.005	0.053	-0.006	-0.806	-0.038	-0.719	1.000	-0.154	-0.006	-0.005	0.053	-0.006	0.110	0.021	0.014	0.033	0.023	0.021	0.052	0.044	0.046	0.360	0.043
week_of_year_first_booking	0.037	0.031	0.168	0.004	0.168	-0.222	0.417	0.005	-0.005	0.422	0.037	0.947	0.159	-0.154	1.000	0.417	0.005	-0.005	0.423	0.111	0.026	0.012	0.035	0.024	0.031	0.053	0.041	0.039	0.291	0.134
month_account_created	0.009	-0.001	0.083	0.005	0.083	-0.495	0.999	-0.012	-0.011	0.975	-0.062	0.440	0.008	-0.006	0.417	1.000	-0.012	-0.011	0.975	0.034	0.054	0.009	0.066	0.063	0.037	0.073	0.063	0.042	0.017	0.307
day_account_created	-0.001	0.011	-0.006	0.001	-0.006	0.003	-0.012	0.999	-0.002	0.057	0.012	-0.002	0.144	-0.005	0.005	-0.012	1.000	-0.002	0.057	0.004	0.006	0.000	0.008	0.017	0.015	0.017	0.009	0.009	0.004	0.015
day_of_week_account_created	0.021	0.034	-0.004	0.000	-0.004	0.013	-0.011	-0.002	0.999	-0.015	0.002	-0.004	-0.001	0.053	-0.005	-0.011	-0.002	1.000	-0.015	0.003	0.005	0.006	0.012	0.013	0.008	0.030	0.031	0.030	0.008	0.010
week_of_year_account_created	0.009	-0.004	0.080	0.006	0.080	-0.481	0.975	0.057	-0.015	0.999	-0.060	0.439	0.018	-0.006	0.423	0.975	0.057	-0.015	1.000	0.031	0.049	0.010	0.063	0.062	0.038	0.068	0.059	0.039	0.017	0.297
gender	0.384	0.098	0.141	0.022	0.157	0.103	0.034	0.004	0.003	0.031	0.126	0.115	0.116	0.110	0.111	0.034	0.004	0.003	0.031	1.000	0.377	0.023	0.065	0.065	0.035	0.050	0.064	0.082	0.126	0.103
signup_method	0.308	0.236	0.102	0.000	0.091	0.086	0.054	0.006	0.005	0.049	0.042	0.026	0.023	0.021	0.026	0.054	0.006	0.005	0.049	0.377	1.000	0.045	0.138	0.121	0.041	0.223	0.190	0.119	0.026	0.086
language	0.029	0.014	0.018	0.000	0.018	0.016	0.009	0.000	0.006	0.010	0.019	0.012	0.012	0.014	0.012	0.009	0.000	0.006	0.010	0.023	0.045	1.000	0.045	0.077	0.030	0.019	0.026	0.042	0.017	0.019
affiliate_channel	0.052	0.365	0.095	0.000	0.084	0.112	0.066	0.008	0.012	0.063	0.086	0.036	0.033	0.033	0.035	0.066	0.008	0.012	0.063	0.065	0.138	0.045	1.000	0.621	0.367	0.286	0.152	0.137	0.040	0.125
affiliate_provider	0.046	0.267	0.090	0.002	0.093	0.140	0.063	0.017	0.013	0.062	0.099	0.025	0.020	0.023	0.024	0.063	0.017	0.013	0.062	0.065	0.121	0.077	0.621	1.000	0.330	0.231	0.120	0.083	0.024	0.157
first_affiliate_tracked	0.043	0.109	0.048	0.000	0.054	0.060	0.037	0.015	0.008	0.038	0.042	0.031	0.023	0.021	0.031	0.037	0.015	0.008	0.038	0.035	0.041	0.030	0.367	0.330	1.000	0.163	0.123	0.138	0.026	0.067
signup_app	0.055	0.569	0.150	0.003	0.161	0.146	0.073	0.017	0.030	0.067	0.086	0.055	0.054	0.052	0.053	0.073	0.017	0.030	0.068	0.050	0.223	0.019	0.286	0.231	0.163	1.000	0.649	0.503	0.061	0.146
first_device_type	0.049	0.282	0.098	0.000	0.089	0.096	0.063	0.009	0.031	0.059	0.065	0.042	0.040	0.044	0.041	0.063	0.009	0.031	0.059	0.064	0.190	0.026	0.152	0.120	0.123	0.649	1.000	0.631	0.045	0.107
first_browser	0.065	0.258	0.085	0.003	0.086	0.100	0.042	0.009	0.030	0.039	0.072	0.040	0.039	0.046	0.039	0.042	0.009	0.030	0.039	0.082	0.119	0.042	0.137	0.083	0.138	0.503	0.631	1.000	0.038	0.113
country_destination	0.103	0.044	0.315	0.003	0.332	0.046	0.017	0.004	0.008	0.017	0.440	0.302	0.312	0.360	0.291	0.017	0.004	0.008	0.017	0.126	0.026	0.017	0.040	0.024	0.026	0.061	0.045	0.038	1.000	0.052
year_account_created	0.063	0.221	0.598	0.011	0.609	0.998	0.307	0.015	0.010	0.297	0.644	0.136	0.044	0.043	0.134	0.307	0.015	0.010	0.297	0.103	0.086	0.019	0.125	0.157	0.067	0.146	0.107	0.113	0.052	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	id	gender	age	signup_method	signup_flow	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	days_from_first_active_untill_booking	days_from_first_active_untill_account_created	days_from_account_created_untill_first_booking	year_first_active	month_first_active	day_first_active	day_of_week__first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	day_of_week_account_created	week_of_year_account_created
0	gxn3p5htnn	-unknown-	49	facebook	0	en	direct	direct	untracked	Web	Mac Desktop	Chrome	NDF	2293	466	1827	2009	3	19	3	12	2015	6	29	0	27	2010	6	28	0	26
1	820tgsjxq7	MALE	38	facebook	0	en	seo	google	untracked	Web	Mac Desktop	Chrome	NDF	2228	732	1496	2009	5	23	5	21	2015	6	29	0	27	2011	5	25	2	21
2	4ft3gnwmtx	FEMALE	56	basic	3	en	direct	direct	untracked	Web	Windows Desktop	IE	US	419	476	-57	2009	6	9	1	24	2010	8	2	0	31	2010	9	28	1	39
3	bjjt8pjhuk	FEMALE	42	facebook	0	en	direct	direct	untracked	Web	Mac Desktop	Firefox	other	1043	765	278	2009	10	31	5	44	2012	9	8	5	36	2011	12	5	0	49
4	87mebub9p4	-unknown-	41	basic	0	en	direct	direct	untracked	Web	Mac Desktop	Chrome	US	72	280	-208	2009	12	8	1	50	2010	2	18	3	7	2010	9	14	1	37
5	osr2jwljor	-unknown-	49	basic	0	en	other	other	omg	Web	Mac Desktop	Chrome	US	1	0	1	2010	1	1	4	53	2010	1	2	5	53	2010	1	1	4	53
6	lsw9q7uk0j	FEMALE	46	basic	0	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US	3	0	3	2010	1	2	5	53	2010	1	5	1	1	2010	1	2	5	53
7	0d01nltbrs	FEMALE	47	basic	0	en	direct	direct	omg	Web	Mac Desktop	Safari	US	10	0	10	2010	1	3	6	53	2010	1	13	2	2	2010	1	3	6	53
8	a1vcnhxeij	FEMALE	50	basic	0	en	other	craigslist	untracked	Web	Mac Desktop	Safari	US	206	0	206	2010	1	4	0	1	2010	7	29	3	30	2010	1	4	0	1
9	6uh8zyj2gn	-unknown-	46	basic	0	en	other	craigslist	omg	Web	Mac Desktop	Firefox	US	0	0	0	2010	1	4	0	1	2010	1	4	0	1	2010	1	4	0	1

	id	gender	age	signup_method	signup_flow	language	affiliate_channel	affiliate_provider	first_affiliate_tracked	signup_app	first_device_type	first_browser	country_destination	days_from_first_active_untill_booking	days_from_account_created_untill_first_booking	year_first_active	month_first_active	day_first_active	week_of_year_first_active	year_first_booking	month_first_booking	day_first_booking	day_of_week_first_booking	week_of_year_first_booking	year_account_created	month_account_created	day_account_created	week_of_year_account_created
213441	omlc9iku7t	FEMALE	34	basic	0	en	direct	direct	linked	Web	Mac Desktop	Chrome	ES	44	44	2014	6	30	27	2014	8	13	2	33	2014	6	30	27
213442	rf0ay567js	-unknown-	49	basic	0	en	sem-brand	google	omg	Web	Mac Desktop	Chrome	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
213443	0k26r3mir0	FEMALE	36	basic	0	en	sem-brand	google	linked	Web	Mac Desktop	Safari	US	13	13	2014	6	30	27	2014	7	13	6	28	2014	6	30	27
213444	40o1ivh6cb	-unknown-	49	basic	0	en	direct	direct	linked	Web	Windows Desktop	Chrome	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
213445	qbxza0xojf	FEMALE	23	basic	0	en	sem-brand	google	omg	Web	Windows Desktop	IE	US	2	2	2014	6	30	27	2014	7	2	2	27	2014	6	30	27
213446	zxodksqpep	MALE	32	basic	0	en	sem-brand	google	omg	Web	Mac Desktop	Safari	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
213447	mhewnxesx9	-unknown-	49	basic	0	en	direct	direct	linked	Web	Windows Desktop	Chrome	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
213448	6o3arsjbb4	-unknown-	32	basic	0	en	direct	direct	untracked	Web	Mac Desktop	Firefox	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
213449	jh95kwisub	-unknown-	49	basic	25	en	other	other	tracked-other	iOS	iPhone	Mobile Safari	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27
213450	nw9fwlyb5f	-unknown-	49	basic	25	en	direct	direct	untracked	iOS	iPhone	-unknown-	NDF	364	364	2014	6	30	27	2015	6	29	0	27	2014	6	30	27

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Dash Punctuation

Most occurring scripts